RetailTransactionRestrictionValidationResult

Entity Definition

Logical Name : RetailTransactionRestrictionValidationResult
Physical Name : NA_RTL_TRN_RSTRCTN_VLD_RSLT

Captures the retailer's validation result as a YES the sale is permitted to a customer based on their answer provided to a RestrictionValidationQuestion in the RetailTransactionRestrictionValidation entity.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SalesRestrictionTypeCode (PK) A unique, automatically assigned code for a specific limitation on an ITEM's sale. TY_RST_SLS Code2 CHAR(2)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) RetailTransactionRestrictionValidation(NA_RTL_TRN_RSTRCTN_VLD)
QuestionID (FK)(PK) A unique identifer for the restriction validation question. ID_QST_RST_VLD Identity integer RetailTransactionRestrictionValidation(NA_RTL_TRN_RSTRCTN_VLD)
ValidationResultFlag A boolean indicator that tells if the customer's answer provided in response to a sales restriction question is accepted by the retailer or not. If yes the customer can purchase the restricted sale item. If NOT the retailer refused to sell the restricted sale item to a customer. Note that this is modeled at the transaction level because while rules are assigned at the line item level, restriction questions (and answers and validation results) happen at a transaction level. For example a retailer is not going to ask to verify a customer's age for each bottle of wine they are purchased. FL_VLD_RSLT Flag integer

Relationships

Parent Entity Verb Phrase Child Entity
RetailTransactionRestrictionValidation validates compliance of RetailTransactionRestrictionValidationResult

Logical Views containing RetailTransactionRestrictionValidationResult

Logical View
Logical 02350 - Retail Transaction - Restriction Validation View